Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 21

In Excel Multiple calculations can be made in a single formula using

a) array formula

b) standard formulas

c) smart formula

d) complex formulas

Question : 22

In Excel if you press …….., the cell accepts your typing as its contents.

a) TAB

b) Enter

c) Insert

d) Ctrl + Enter

Question : 23

In Excel you can use the formula palette to

a) Copy a range of cells

b) Enter assumptions data

c) Create and edit formulas containing functions

d) Format cells containing numbers

Question : 24

In Excel default header for a worksheet is

a) None

b) Your name

c) The sheet tab name

d) The date and time

Question : 25

In Excel to select an individual data marker or data label, you must

a) Click once to select the series markers or labels and click the desired marker or label again

b) Double click the data series

c) Double click the marker or label

d) Double click the data series